home *** CD-ROM | disk | FTP | other *** search
/ Agent Central Host Computer / Agent - Central Host Computer.iso / _SETUP.1 / vckprobehist.sql < prev    next >
Text File  |  2000-05-12  |  310b  |  12 lines
  1. /*
  2. checks to ensure that all probed fareboxes are entered in the farebox table
  3. */
  4. CREATE OR REPLACE VIEW VCKPROBEHIST AS select probehist.conversion_num, 
  5. probehist.farebox_glid  
  6. from probehist  
  7. where not exists 
  8. (select farebox.glid from farebox 
  9.     where farebox.glid = probehist.farebox_glid);
  10.  
  11.  
  12.